package com.cqjtu.eecs.mapper;

import com.cqjtu.eecs.entity.CourseGoal;
import com.cqjtu.eecs.entity.dto.AttendedCourseDto;
import com.cqjtu.eecs.entity.dto.StudentScoreName;
import com.cqjtu.eecs.entity.vo.CourseScoreVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Set;

@Mapper
public interface AnalysisMapper {

    // 获取自然班已修读总课程门数和学分
    AttendedCourseDto getAttendedCourseDto(Integer ncId);

    // 获取自然班所修各课程的总成绩和课程名
    List<CourseScoreVo> getCourseScoreName(Integer ncId);


    StudentScoreName getAvgStudent(@Param("ncId") Integer ncId, @Param("sort") Boolean sort);

    List<Integer> getAttendedCourseIdList(List<CourseScoreVo> courseScoreNameList);

    List<Integer> getCourseIdByRequirementId(Integer requirementId);

    List<Integer> getTeachClassBySid(Integer sid);

    List<String> getCourseNamesByTcIds(List<Integer> tcIds);

    List<String> getEnhancedCourseName(@Param("courseIds") Set<Integer> courseIds, @Param("courseNames") List<String> attendedCourse);
}
